Tabela PatientLevelOld

Definicja tabeli PatientLevelOld

Name

PatientLevelOld

Code

PatientLevelOld

Comment

 


Lista kolumn tabeli PatientLevelOld

Name

Code

PatNam

PatNam

PatID

PatID

PatBirDat

PatBirDat

PatBirTim

PatBirTim

PatSex

PatSex

NumPatRelStu

NumPatRelStu

NumPatRelSer

NumPatRelSer

NumPatRelIma

NumPatRelIma

InsertDate

InsertDate

InsertTime

InsertTime

Owner

Owner

GroupName

GroupName

Priv

Priv

PatCustom1

PatCustom1

PatCustom2

PatCustom2

PatCustom3

PatCustom3


Kolumna PatNam tabeli PatientLevelOld

Definicja kolumny PatNam tabeli PatientLevelOld

Name

PatNam

Code

PatNam

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna PatID tabeli PatientLevelOld

Definicja kolumny PatID tabeli PatientLevelOld

Name

PatID

Code

PatID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna PatBirDat tabeli PatientLevelOld

Definicja kolumny PatBirDat tabeli PatientLevelOld

Name

PatBirDat

Code

PatBirDat

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatBirTim tabeli PatientLevelOld

Definicja kolumny PatBirTim tabeli PatientLevelOld

Name

PatBirTim

Code

PatBirTim

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna PatSex tabeli PatientLevelOld

Definicja kolumny PatSex tabeli PatientLevelOld

Name

PatSex

Code

PatSex

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

 


Kolumna NumPatRelStu tabeli PatientLevelOld

Definicja kolumny NumPatRelStu tabeli PatientLevelOld

Name

NumPatRelStu

Code

NumPatRelStu

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NumPatRelSer tabeli PatientLevelOld

Definicja kolumny NumPatRelSer tabeli PatientLevelOld

Name

NumPatRelSer

Code

NumPatRelSer

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NumPatRelIma tabeli PatientLevelOld

Definicja kolumny NumPatRelIma tabeli PatientLevelOld

Name

NumPatRelIma

Code

NumPatRelIma

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDate tabeli PatientLevelOld

Definicja kolumny InsertDate tabeli PatientLevelOld

Name

InsertDate

Code

InsertDate

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertTime tabeli PatientLevelOld

Definicja kolumny InsertTime tabeli PatientLevelOld

Name

InsertTime

Code

InsertTime

Data Type

FLOAT

Mandatory

Yes

Comment

 


Kolumna Owner tabeli PatientLevelOld

Definicja kolumny Owner tabeli PatientLevelOld

Name

Owner

Code

Owner

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna GroupName tabeli PatientLevelOld

Definicja kolumny GroupName tabeli PatientLevelOld

Name

GroupName

Code

GroupName

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Priv tabeli PatientLevelOld

Definicja kolumny Priv tabeli PatientLevelOld

Name

Priv

Code

Priv

Data Type

VARCHAR2(9)

Mandatory

No

Comment

 


Kolumna PatCustom1 tabeli PatientLevelOld

Definicja kolumny PatCustom1 tabeli PatientLevelOld

Name

PatCustom1

Code

PatCustom1

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Kolumna PatCustom2 tabeli PatientLevelOld

Definicja kolumny PatCustom2 tabeli PatientLevelOld

Name

PatCustom2

Code

PatCustom2

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Kolumna PatCustom3 tabeli PatientLevelOld

Definicja kolumny PatCustom3 tabeli PatientLevelOld

Name

PatCustom3

Code

PatCustom3

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Custom field at patient level


Lista kluczy tabeli PatientLevelOld

Name

Code

Primary

PL_PatID_index

PL_PatID_index

X


Klucz PL_PatID_index tabeli PatientLevelOld

Definicja klucza PL_PatID_index tabeli PatientLevelOld

Name

PL_PatID_index

Code

PL_PatID_index

Primary

Yes

Comment